﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Net;
using System.Windows;
using System.Windows.Controls;
using System.Windows.Documents;
using System.Windows.Input;
using System.Windows.Media;
using System.Windows.Media.Animation;
using System.Windows.Navigation;
using System.Windows.Shapes;
using Microsoft.Phone.Controls;
using Microsoft.Phone.Shell;
using System.Diagnostics;
using System.Collections.ObjectModel;

namespace PostIt
{
    public partial class App : Application
    {
        private static MainViewModel viewModel = null;

        private const string DBConnectionString = "Data Source=isostore:/tasksDB.sdf";

        private static TasksDBContext _db = null;

        public static TasksDBContext DB
        {
            get
            {
                if (_db == null)
                    _db = new TasksDBContext(DBConnectionString);

                return _db;
            }
        }
        /// <summary>
        /// A static ViewModel used by the views to bind against.
        /// </summary>
        /// <returns>The MainViewModel object.</returns>
        public static MainViewModel ViewModel
        {
            get
            {
                // Delay creation of the view model until necessary
                if (viewModel == null)
                    viewModel = new MainViewModel();

                return viewModel;
            }
        }

        /// <summary>
        /// Provides easy access to the root frame of the Phone Application.
        /// </summary>
        /// <returns>The root frame of the Phone Application.</returns>
        public PhoneApplicationFrame RootFrame { get; private set; }

        /// <summary>
        /// Constructor for the Application object.
        /// </summary>
        public App()
        {
            TasksDBContext db;

            // Create the database if it does not exist.
            db = App.DB;

            // Global handler for uncaught exceptions. 
            // Note that exceptions thrown by ApplicationBarItem.Click will not get caught here.
            UnhandledException += Application_UnhandledException;

            // Show graphics profiling information while debugging.
            if (System.Diagnostics.Debugger.IsAttached)
            {
                // Display the current frame rate counters.
                Application.Current.Host.Settings.EnableFrameRateCounter = true;

                // Show the areas of the app that are being redrawn in each frame.
                //Application.Current.Host.Settings.EnableRedrawRegions = true;

                // Enable non-production analysis visualization mode, 
                // which shows areas of a page that are being GPU accelerated with a colored overlay.
                //Application.Current.Host.Settings.EnableCacheVisualization = true;
            }

            // Standard Silverlight initialization
            InitializeComponent();

            // Phone-specific initialization
            InitializePhoneApplication();
            if (db.DatabaseExists() == false)
            {
                

                // Create the local database.
                //add some sample tasks

                db.CreateDatabase();
                db.Items.InsertOnSubmit(new Tasks
                    {
                        isDone = false,
                        Title = "study the math",
                        tileText = "math study",
                        CreationDate = DateTime.Now,
                        Detail = "I should study the pages 4  up to 10 from the book x",
                        DueDate = DateTime.Now,
                        backColor = "#FFFF0097"
                    });
                db.Items.InsertOnSubmit(new Tasks
                {
                    isDone = false,
                    isPin = false,
                    Title = "lunch",
                    tileText = "eat the lunch",
                    CreationDate = DateTime.Now,
                    Detail = "I should eat a vegeterian food.",
                    DueDate = DateTime.Now,
                    backColor = "#FFF09609"
                });
                db.Items.InsertOnSubmit(new Tasks
                {
                    isDone = true,
                    isPin = false,

                    Title = "study the algebra",
                    tileText = "algebra",
                    CreationDate = DateTime.Now,
                    Detail = "I should study the pages 6  up to 10 from the book x",
                    DueDate = DateTime.Now,
                    backColor = "#FF8CBF26"
                });
                db.Items.InsertOnSubmit(new Tasks
                {
                    isDone = false,
                    isPin = false,
                    Title = "eat the dinner",
                    tileText = "dinner",
                    CreationDate = DateTime.Now,
                    Detail = "I should eat dinner tonight at 8",
                    DueDate = DateTime.Now,
                    backColor = "#FF1BA1E2"
                });
                db.SubmitChanges();
           



            }
           
        }

        private ShellTile FindTile(string partOfUri)
        {
            ShellTile shellTile = ShellTile.ActiveTiles.FirstOrDefault(
                tile => tile.NavigationUri.ToString() == "/DetailsPage.xaml?" + partOfUri);

            return shellTile;
        }
        
        // checks if there is no task for pined item then change db 
        private void checkDeletedTiles()
        {
            var tasksDB = from Tasks s in App.DB.Items
                          select s;

            // Query the database and load all to-do items.
            var allTask = new ObservableCollection<Tasks>(tasksDB);

            foreach (Tasks aTask in allTask)
            {

                if (aTask.isPin == true && (FindTile("taskId=" + aTask.TaskId) == null))
                {
                    aTask.isPin = false;
                    aTask.isDone = true;

                }

            }
            App.DB.SubmitChanges();


        }
        // Code to execute when the application is launching (eg, from Start)
        // This code will not execute when the application is reactivated
        private void Application_Launching(object sender, LaunchingEventArgs e)
        {
            // checks if there is no task for pined item then change db 
            checkDeletedTiles();
        }

        // Code to execute when the application is activated (brought to foreground)
        // This code will not execute when the application is first launched
        private void Application_Activated(object sender, ActivatedEventArgs e)
        {
            // checks if there is no task for pined item then change db 
            checkDeletedTiles();
            if (!App.ViewModel.IsDataLoaded)
            {
                App.ViewModel.LoadData();

            }
            else
            {

                App.viewModel.Items.Clear();
                App.viewModel.LoadData();
            }
        }

        // Code to execute when the application is deactivated (sent to background)
        // This code will not execute when the application is closing
        private void Application_Deactivated(object sender, DeactivatedEventArgs e)
        {
        }

        // Code to execute when the application is closing (eg, user hit Back)
        // This code will not execute when the application is deactivated
        private void Application_Closing(object sender, ClosingEventArgs e)
        {
        }

        // Code to execute if a navigation fails
        private void RootFrame_NavigationFailed(object sender, NavigationFailedEventArgs e)
        {
            if (System.Diagnostics.Debugger.IsAttached)
            {
                // A navigation has failed; break into the debugger
                System.Diagnostics.Debugger.Break();
            }
        }

        // Code to execute on Unhandled Exceptions
        private void Application_UnhandledException(object sender, ApplicationUnhandledExceptionEventArgs e)
        {
            if (System.Diagnostics.Debugger.IsAttached)
            {
                // An unhandled exception has occurred; break into the debugger
                System.Diagnostics.Debugger.Break();
            }
        }

        #region Phone application initialization

        // Avoid double-initialization
        private bool phoneApplicationInitialized = false;

        // Do not add any additional code to this method
        private void InitializePhoneApplication()
        {
            if (phoneApplicationInitialized)
                return;

            // Create the frame but don't set it as RootVisual yet; this allows the splash
            // screen to remain active until the application is ready to render.
            RootFrame = new PhoneApplicationFrame();
            RootFrame.Navigated += CompleteInitializePhoneApplication;

            // Handle navigation failures
            RootFrame.NavigationFailed += RootFrame_NavigationFailed;

            // Ensure we don't initialize again
            phoneApplicationInitialized = true;
        }

        // Do not add any additional code to this method
        private void CompleteInitializePhoneApplication(object sender, NavigationEventArgs e)
        {
            // Set the root visual to allow the application to render
            if (RootVisual != RootFrame)
                RootVisual = RootFrame;

            // Remove this handler since it is no longer needed
            RootFrame.Navigated -= CompleteInitializePhoneApplication;
        }

        #endregion
    }
}